Dataset info
| Number of variables | 28 |
|---|---|
| Number of observations | 5043 |
| Missing cells | 2191 (1.6%) |
| Duplicate rows | 45 (0.9%) |
| Total size in memory | 5.1 MiB |
| Average record size in memory | 1.0 KiB |
Variables types
| NUM | 16 |
|---|---|
| CAT | 11 |
| URL | 1 |
Reproduction info
| Date of analysis | 2020-03-10 18:59:09.625040 |
|---|---|
| Version | pandas-profiling v2.4.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download Configuration | config.yaml |
Warnings
| Dataset has 45 (0.9%) duplicate rows | Warning |
actor_1_name has a high cardinality: 2098 distinct values | Warning |
actor_2_fb_likes has 55 (1.1%) zeros | Zeros |
actor_2_name has a high cardinality: 3033 distinct values | Warning |
actor_3_fb_likes has 89 (1.8%) zeros | Zeros |
actor_3_name has a high cardinality: 3522 distinct values | Warning |
aspect_ratio has 329 (6.5%) missing values | Missing |
budget has 403 (8.0%) missing values | Missing |
budget is highly skewed (γ1 = 48.59279525) | Skewed |
content_rating has 303 (6.0%) missing values | Missing |
country has a high cardinality: 66 distinct values | Warning |
director_fb_likes has 104 (2.1%) missing values | Missing |
director_fb_likes has 907 (18.0%) zeros | Zeros |
director_name has 104 (2.1%) missing values | Missing |
director_name has a high cardinality: 2399 distinct values | Warning |
facenumber_in_poster has 2152 (42.7%) zeros | Zeros |
genres has a high cardinality: 914 distinct values | Warning |
gross has 466 (9.2%) missing values | Missing |
movie_fb_likes has 2181 (43.2%) zeros | Zeros |
movie_title has a high cardinality: 4917 distinct values | Warning |
plot_keywords has 153 (3.0%) missing values | Missing |
plot_keywords has a high cardinality: 4761 distinct values | Warning |
title_year has 108 (2.1%) missing values | Missing |
cast_total_fb_likes is highly correlated with actor_1_fb_likes | High Correlation |
actor_1_fb_likes is highly correlated with cast_total_fb_likes | High Correlation |
| Distinct count | 879 |
|---|---|
| Unique (%) | 17.4% |
| Missing | 7 |
| Missing (%) | 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6560.047061 |
|---|---|
| Minimum | 0 |
| Maximum | 640000 |
| Zeros | 26 |
| Zeros (%) | 0.5% |
| Memory size | 39.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 95.5 |
| Q1 | 614 |
| median | 988 |
| Q3 | 11000 |
| 95-th percentile | 24000 |
| Maximum | 640000 |
| Range | 640000 |
| Interquartile range (IQR) | 10386 |
Descriptive statistics
| Standard deviation | 15020.75912 |
|---|---|
| Coefficient of variation (CV) | 2.289733439 |
| Kurtosis | 683.5473559 |
| Mean | 6560.047061 |
| Median Absolute Deviation (MAD) | 7727.675203 |
| Skewness | 19.12177638 |
| Sum | 33036397 |
| Variance | 225623204.5 |
| Value | Count | Frequency (%) | |
| 1000 | 449 | 8.9% | |
| 11000 | 211 | 4.2% | |
| 2000 | 197 | 3.9% | |
| 3000 | 155 | 3.1% | |
| 12000 | 135 | 2.7% | |
| 13000 | 127 | 2.5% | |
| 14000 | 123 | 2.4% | |
| 10000 | 112 | 2.2% | |
| 18000 | 109 | 2.2% | |
| 22000 | 82 | 1.6% | |
| Other values (868) | 3336 | 66.2% |
| Value | Count | Frequency (%) | |
| 0 | 26 | 0.5% | |
| 2 | 8 | 0.2% | |
| 3 | 4 | 0.1% | |
| 4 | 2 | < 0.1% | |
| 5 | 7 | 0.1% |
| Value | Count | Frequency (%) | |
| 640000 | 1 | < 0.1% | |
| 260000 | 3 | 0.1% | |
| 164000 | 2 | < 0.1% | |
| 137000 | 2 | < 0.1% | |
| 87000 | 8 | 0.2% |
| Distinct count | 2098 |
|---|---|
| Unique (%) | 41.6% |
| Missing | 7 |
| Missing (%) | 0.1% |
| Memory size | 39.5 KiB |
| Robert De Niro | 49 |
|---|---|
| Johnny Depp | 41 |
| Nicolas Cage | 33 |
| J.K. Simmons | 31 |
| Matt Damon | 30 |
| Other values (2092) |
| Value | Count | Frequency (%) | |
| Robert De Niro | 49 | 1.0% | |
| Johnny Depp | 41 | 0.8% | |
| Nicolas Cage | 33 | 0.7% | |
| J.K. Simmons | 31 | 0.6% | |
| Matt Damon | 30 | 0.6% | |
| Bruce Willis | 30 | 0.6% | |
| Denzel Washington | 30 | 0.6% | |
| Liam Neeson | 29 | 0.6% | |
| Harrison Ford | 27 | 0.5% | |
| Steve Buscemi | 27 | 0.5% | |
| Other values (2087) | 4709 | 93.4% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | True |
| Contains non-words | True |
Length
| Max length | 27 |
|---|---|
| Mean length | 13.1782669 |
| Min length | 3 |
| Distinct count | 918 |
|---|---|
| Unique (%) | 18.2% |
| Missing | 13 |
| Missing (%) | 0.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1651.754473 |
|---|---|
| Minimum | 0 |
| Maximum | 137000 |
| Zeros | 55 |
| Zeros (%) | 1.1% |
| Memory size | 39.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 26 |
| Q1 | 281 |
| median | 595 |
| Q3 | 918 |
| 95-th percentile | 11000 |
| Maximum | 137000 |
| Range | 137000 |
| Interquartile range (IQR) | 637 |
Descriptive statistics
| Standard deviation | 4042.438863 |
|---|---|
| Coefficient of variation (CV) | 2.447360627 |
| Kurtosis | 256.7951889 |
| Mean | 1651.754473 |
| Median Absolute Deviation (MAD) | 1979.395883 |
| Skewness | 9.884733179 |
| Sum | 8308325 |
| Variance | 16341311.96 |
| Value | Count | Frequency (%) | |
| 1000 | 309 | 6.1% | |
| 11000 | 111 | 2.2% | |
| 2000 | 100 | 2.0% | |
| 3000 | 76 | 1.5% | |
| 0 | 55 | 1.1% | |
| 10000 | 47 | 0.9% | |
| 14000 | 41 | 0.8% | |
| 13000 | 40 | 0.8% | |
| 826 | 37 | 0.7% | |
| 4000 | 34 | 0.7% | |
| Other values (907) | 4180 | 82.9% |
| Value | Count | Frequency (%) | |
| 0 | 55 | 1.1% | |
| 2 | 14 | 0.3% | |
| 3 | 14 | 0.3% | |
| 4 | 12 | 0.2% | |
| 5 | 10 | 0.2% |
| Value | Count | Frequency (%) | |
| 137000 | 1 | < 0.1% | |
| 29000 | 1 | < 0.1% | |
| 27000 | 2 | < 0.1% | |
| 25000 | 3 | 0.1% | |
| 23000 | 6 | 0.1% |
| Distinct count | 3033 |
|---|---|
| Unique (%) | 60.1% |
| Missing | 13 |
| Missing (%) | 0.3% |
| Memory size | 39.5 KiB |
| Morgan Freeman | 20 |
|---|---|
| Charlize Theron | 15 |
| Brad Pitt | 14 |
| James Franco | 11 |
| Meryl Streep | 11 |
| Other values (3027) |
| Value | Count | Frequency (%) | |
| Morgan Freeman | 20 | 0.4% | |
| Charlize Theron | 15 | 0.3% | |
| Brad Pitt | 14 | 0.3% | |
| James Franco | 11 | 0.2% | |
| Meryl Streep | 11 | 0.2% | |
| Jason Flemyng | 10 | 0.2% | |
| Adam Sandler | 10 | 0.2% | |
| Steve Buscemi | 9 | 0.2% | |
| Angelina Jolie Pitt | 9 | 0.2% | |
| Bruce Willis | 9 | 0.2% | |
| Other values (3022) | 4912 | 97.4% | |
| (Missing) | 13 | 0.3% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | True |
| Contains non-words | True |
Length
| Max length | 28 |
|---|---|
| Mean length | 13.0483839 |
| Min length | 3 |
| Distinct count | 907 |
|---|---|
| Unique (%) | 18.0% |
| Missing | 23 |
| Missing (%) | 0.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 645.009761 |
|---|---|
| Minimum | 0 |
| Maximum | 23000 |
| Zeros | 89 |
| Zeros (%) | 1.8% |
| Memory size | 39.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 10 |
| Q1 | 133 |
| median | 371.5 |
| Q3 | 636 |
| 95-th percentile | 1000 |
| Maximum | 23000 |
| Range | 23000 |
| Interquartile range (IQR) | 503 |
Descriptive statistics
| Standard deviation | 1665.041728 |
|---|---|
| Coefficient of variation (CV) | 2.581420979 |
| Kurtosis | 60.56388811 |
| Mean | 645.009761 |
| Median Absolute Deviation (MAD) | 569.3467201 |
| Skewness | 7.279020793 |
| Sum | 3237949 |
| Variance | 2772363.957 |
| Value | Count | Frequency (%) | |
| 1000 | 126 | 2.5% | |
| 0 | 89 | 1.8% | |
| 11000 | 29 | 0.6% | |
| 3 | 28 | 0.6% | |
| 2000 | 27 | 0.5% | |
| 3000 | 26 | 0.5% | |
| 826 | 22 | 0.4% | |
| 2 | 21 | 0.4% | |
| 4 | 21 | 0.4% | |
| 7 | 21 | 0.4% | |
| Other values (896) | 4610 | 91.4% | |
| (Missing) | 23 | 0.5% |
| Value | Count | Frequency (%) | |
| 0 | 89 | 1.8% | |
| 2 | 21 | 0.4% | |
| 3 | 28 | 0.6% | |
| 4 | 21 | 0.4% | |
| 5 | 18 | 0.4% |
| Value | Count | Frequency (%) | |
| 23000 | 2 | < 0.1% | |
| 20000 | 1 | < 0.1% | |
| 19000 | 5 | 0.1% | |
| 17000 | 1 | < 0.1% | |
| 16000 | 3 | 0.1% |
| Distinct count | 3522 |
|---|---|
| Unique (%) | 69.8% |
| Missing | 23 |
| Missing (%) | 0.5% |
| Memory size | 39.5 KiB |
| Steve Coogan | 8 |
|---|---|
| Ben Mendelsohn | 8 |
| John Heard | 8 |
| Sam Shepard | 7 |
| Jon Gries | 7 |
| Other values (3516) |
| Value | Count | Frequency (%) | |
| Steve Coogan | 8 | 0.2% | |
| Ben Mendelsohn | 8 | 0.2% | |
| John Heard | 8 | 0.2% | |
| Sam Shepard | 7 | 0.1% | |
| Jon Gries | 7 | 0.1% | |
| Robert Duvall | 7 | 0.1% | |
| Lois Maxwell | 7 | 0.1% | |
| Stephen Root | 7 | 0.1% | |
| Anne Hathaway | 7 | 0.1% | |
| Kirsten Dunst | 7 | 0.1% | |
| Other values (3511) | 4947 | 98.1% | |
| (Missing) | 23 | 0.5% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | True |
| Contains non-words | True |
Length
| Max length | 29 |
|---|---|
| Mean length | 13.03628792 |
| Min length | 3 |
| Distinct count | 23 |
|---|---|
| Unique (%) | 0.5% |
| Missing | 329 |
| Missing (%) | 6.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.220403055 |
|---|---|
| Minimum | 1.18 |
| Maximum | 16 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 39.5 KiB |
Quantile statistics
| Minimum | 1.18 |
|---|---|
| 5-th percentile | 1.66 |
| Q1 | 1.85 |
| median | 2.35 |
| Q3 | 2.35 |
| 95-th percentile | 2.35 |
| Maximum | 16 |
| Range | 14.82 |
| Interquartile range (IQR) | 0.5 |
Descriptive statistics
| Standard deviation | 1.385112535 |
|---|---|
| Coefficient of variation (CV) | 0.6238113087 |
| Kurtosis | 90.65322055 |
| Mean | 2.220403055 |
| Median Absolute Deviation (MAD) | 0.4004107589 |
| Skewness | 9.390056312 |
| Sum | 10466.98 |
| Variance | 1.918536735 |
| Value | Count | Frequency (%) | |
| 2.35 | 2360 | 46.8% | |
| 1.85 | 1906 | 37.8% | |
| 1.78 | 110 | 2.2% | |
| 1.37 | 100 | 2.0% | |
| 1.33 | 68 | 1.3% | |
| 1.66 | 64 | 1.3% | |
| 16 | 45 | 0.9% | |
| 2.2 | 15 | 0.3% | |
| 2.39 | 15 | 0.3% | |
| 4 | 7 | 0.1% | |
| Other values (12) | 24 | 0.5% | |
| (Missing) | 329 | 6.5% |
| Value | Count | Frequency (%) | |
| 1.18 | 1 | < 0.1% | |
| 1.2 | 1 | < 0.1% | |
| 1.33 | 68 | 1.3% | |
| 1.37 | 100 | 2.0% | |
| 1.44 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 16 | 45 | 0.9% | |
| 4 | 7 | 0.1% | |
| 2.76 | 3 | 0.1% | |
| 2.55 | 2 | < 0.1% | |
| 2.4 | 3 | 0.1% |
| Distinct count | 443 |
|---|---|
| Unique (%) | 8.8% |
| Missing | 403 |
| Missing (%) | 8.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 39386466.73 |
|---|---|
| Minimum | 218 |
| Maximum | 1.22155e+10 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 39.5 KiB |
Quantile statistics
| Minimum | 218 |
|---|---|
| 5-th percentile | 500000 |
| Q1 | 6000000 |
| median | 20000000 |
| Q3 | 44000000 |
| 95-th percentile | 130000000 |
| Maximum | 1.22155e+10 |
| Range | 1.221549978e+10 |
| Interquartile range (IQR) | 38000000 |
Descriptive statistics
| Standard deviation | 204181882.1 |
|---|---|
| Coefficient of variation (CV) | 5.184061916 |
| Kurtosis | 2774.956653 |
| Mean | 39386466.73 |
| Median Absolute Deviation (MAD) | 37365363.95 |
| Skewness | 48.59279525 |
| Sum | 1.827532056e+11 |
| Variance | 4.1690241e+16 |
| Value | Count | Frequency (%) | |
| 20000000 | 179 | 3.5% | |
| 30000000 | 147 | 2.9% | |
| 15000000 | 146 | 2.9% | |
| 25000000 | 143 | 2.8% | |
| 10000000 | 143 | 2.8% | |
| 40000000 | 134 | 2.7% | |
| 35000000 | 120 | 2.4% | |
| 5000000 | 111 | 2.2% | |
| 50000000 | 106 | 2.1% | |
| 12000000 | 95 | 1.9% | |
| Other values (432) | 3316 | 65.8% | |
| (Missing) | 403 | 8.0% |
| Value | Count | Frequency (%) | |
| 218 | 1 | < 0.1% | |
| 1100 | 1 | < 0.1% | |
| 1400 | 1 | < 0.1% | |
| 3250 | 1 | < 0.1% | |
| 4500 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 1.22155e+10 | 1 | < 0.1% | |
| 4200000000 | 1 | < 0.1% | |
| 2500000000 | 1 | < 0.1% | |
| 2400000000 | 1 | < 0.1% | |
| 2127519898 | 1 | < 0.1% |
| Distinct count | 3978 |
|---|---|
| Unique (%) | 78.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9699.063851 |
|---|---|
| Minimum | 0 |
| Maximum | 656730 |
| Zeros | 33 |
| Zeros (%) | 0.7% |
| Memory size | 39.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 179 |
| Q1 | 1411 |
| median | 3090 |
| Q3 | 13756.5 |
| 95-th percentile | 36927.7 |
| Maximum | 656730 |
| Range | 656730 |
| Interquartile range (IQR) | 12345.5 |
Descriptive statistics
| Standard deviation | 18163.79912 |
|---|---|
| Coefficient of variation (CV) | 1.872737349 |
| Kurtosis | 361.2551153 |
| Mean | 9699.063851 |
| Median Absolute Deviation (MAD) | 10152.51874 |
| Skewness | 12.83192773 |
| Sum | 48912379 |
| Variance | 329923598.6 |
| Value | Count | Frequency (%) | |
| 0 | 33 | 0.7% | |
| 5 | 7 | 0.1% | |
| 2020 | 6 | 0.1% | |
| 2 | 6 | 0.1% | |
| 1044 | 5 | 0.1% | |
| 673 | 5 | 0.1% | |
| 29 | 5 | 0.1% | |
| 2321 | 4 | 0.1% | |
| 1554 | 4 | 0.1% | |
| 646 | 4 | 0.1% | |
| Other values (3968) | 4964 | 98.4% |
| Value | Count | Frequency (%) | |
| 0 | 33 | 0.7% | |
| 2 | 6 | 0.1% | |
| 3 | 1 | < 0.1% | |
| 4 | 2 | < 0.1% | |
| 5 | 7 | 0.1% |
| Value | Count | Frequency (%) | |
| 656730 | 1 | < 0.1% | |
| 303717 | 1 | < 0.1% | |
| 283939 | 1 | < 0.1% | |
| 263584 | 1 | < 0.1% | |
| 261818 | 1 | < 0.1% |
color
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 19 |
| Missing (%) | 0.4% |
| Memory size | 39.5 KiB |
| Color | |
|---|---|
| Black and White | 209 |
| Value | Count | Frequency (%) | |
| Color | 4815 | 95.5% | |
| Black and White | 209 | 4.1% | |
| (Missing) | 19 | 0.4% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | True |
| Contains non-words | True |
Length
| Max length | 16 |
|---|---|
| Mean length | 5.44834424 |
| Min length | 3 |
| Distinct count | 19 |
|---|---|
| Unique (%) | 0.4% |
| Missing | 303 |
| Missing (%) | 6.0% |
| Memory size | 39.5 KiB |
| R | |
|---|---|
| PG-13 | |
| PG | |
| Not Rated | 116 |
| G | 112 |
| Other values (13) | 232 |
| Value | Count | Frequency (%) | |
| R | 2118 | 42.0% | |
| PG-13 | 1461 | 29.0% | |
| PG | 701 | 13.9% | |
| Not Rated | 116 | 2.3% | |
| G | 112 | 2.2% | |
| Unrated | 62 | 1.2% | |
| Approved | 55 | 1.1% | |
| TV-14 | 30 | 0.6% | |
| TV-MA | 20 | 0.4% | |
| TV-PG | 13 | 0.3% | |
| Other values (8) | 52 | 1.0% | |
| (Missing) | 303 | 6.0% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | True |
| Contains non-words | True |
Length
| Max length | 9 |
|---|---|
| Mean length | 2.825104105 |
| Min length | 1 |
| Distinct count | 66 |
|---|---|
| Unique (%) | 1.3% |
| Missing | 5 |
| Missing (%) | 0.1% |
| Memory size | 39.5 KiB |
| USA | |
|---|---|
| UK | 448 |
| France | 154 |
| Canada | 126 |
| Germany | 97 |
| Other values (60) | 406 |
| Value | Count | Frequency (%) | |
| USA | 3807 | 75.5% | |
| UK | 448 | 8.9% | |
| France | 154 | 3.1% | |
| Canada | 126 | 2.5% | |
| Germany | 97 | 1.9% | |
| Australia | 55 | 1.1% | |
| India | 34 | 0.7% | |
| Spain | 33 | 0.7% | |
| China | 30 | 0.6% | |
| Japan | 23 | 0.5% | |
| Other values (55) | 231 | 4.6% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | True |
| Contains non-words | True |
Length
| Max length | 20 |
|---|---|
| Mean length | 3.488796351 |
| Min length | 2 |
| Distinct count | 436 |
|---|---|
| Unique (%) | 8.6% |
| Missing | 104 |
| Missing (%) | 2.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 686.5092124 |
|---|---|
| Minimum | 0 |
| Maximum | 23000 |
| Zeros | 907 |
| Zeros (%) | 18.0% |
| Memory size | 39.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 7 |
| median | 49 |
| Q3 | 194.5 |
| 95-th percentile | 973 |
| Maximum | 23000 |
| Range | 23000 |
| Interquartile range (IQR) | 187.5 |
Descriptive statistics
| Standard deviation | 2813.328607 |
|---|---|
| Coefficient of variation (CV) | 4.098020181 |
| Kurtosis | 27.25628935 |
| Mean | 686.5092124 |
| Median Absolute Deviation (MAD) | 1069.818414 |
| Skewness | 5.22970117 |
| Sum | 3390669 |
| Variance | 7914817.85 |
| Value | Count | Frequency (%) | |
| 0 | 907 | 18.0% | |
| 3 | 70 | 1.4% | |
| 6 | 66 | 1.3% | |
| 7 | 64 | 1.3% | |
| 2 | 63 | 1.2% | |
| 4 | 60 | 1.2% | |
| 11 | 59 | 1.2% | |
| 10 | 53 | 1.1% | |
| 8 | 52 | 1.0% | |
| 5 | 52 | 1.0% | |
| Other values (425) | 3493 | 69.3% | |
| (Missing) | 104 | 2.1% |
| Value | Count | Frequency (%) | |
| 0 | 907 | 18.0% | |
| 2 | 63 | 1.2% | |
| 3 | 70 | 1.4% | |
| 4 | 60 | 1.2% | |
| 5 | 52 | 1.0% |
| Value | Count | Frequency (%) | |
| 23000 | 1 | < 0.1% | |
| 22000 | 8 | 0.2% | |
| 21000 | 10 | 0.2% | |
| 20000 | 1 | < 0.1% | |
| 18000 | 4 | 0.1% |
| Distinct count | 2399 |
|---|---|
| Unique (%) | 47.6% |
| Missing | 104 |
| Missing (%) | 2.1% |
| Memory size | 39.5 KiB |
| Steven Spielberg | 26 |
|---|---|
| Woody Allen | 22 |
| Martin Scorsese | 20 |
| Clint Eastwood | 20 |
| Ridley Scott | 17 |
| Other values (2393) |
| Value | Count | Frequency (%) | |
| Steven Spielberg | 26 | 0.5% | |
| Woody Allen | 22 | 0.4% | |
| Martin Scorsese | 20 | 0.4% | |
| Clint Eastwood | 20 | 0.4% | |
| Ridley Scott | 17 | 0.3% | |
| Tim Burton | 16 | 0.3% | |
| Steven Soderbergh | 16 | 0.3% | |
| Spike Lee | 16 | 0.3% | |
| Renny Harlin | 15 | 0.3% | |
| Oliver Stone | 14 | 0.3% | |
| Other values (2388) | 4757 | 94.3% | |
| (Missing) | 104 | 2.1% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | True |
| Contains non-words | True |
Length
| Max length | 32 |
|---|---|
| Mean length | 12.87685901 |
| Min length | 3 |
duration
Real number (ℝ≥0)
| Distinct count | 192 |
|---|---|
| Unique (%) | 3.8% |
| Missing | 15 |
| Missing (%) | 0.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 107.201074 |
|---|---|
| Minimum | 7 |
| Maximum | 511 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 39.5 KiB |
Quantile statistics
| Minimum | 7 |
|---|---|
| 5-th percentile | 81 |
| Q1 | 93 |
| median | 103 |
| Q3 | 118 |
| 95-th percentile | 146 |
| Maximum | 511 |
| Range | 504 |
| Interquartile range (IQR) | 25 |
Descriptive statistics
| Standard deviation | 25.19744081 |
|---|---|
| Coefficient of variation (CV) | 0.235048399 |
| Kurtosis | 22.56579716 |
| Mean | 107.201074 |
| Median Absolute Deviation (MAD) | 16.81590041 |
| Skewness | 2.339134041 |
| Sum | 539007 |
| Variance | 634.9110233 |
| Value | Count | Frequency (%) | |
| 90 | 161 | 3.2% | |
| 100 | 141 | 2.8% | |
| 101 | 139 | 2.8% | |
| 98 | 135 | 2.7% | |
| 97 | 131 | 2.6% | |
| 93 | 129 | 2.6% | |
| 95 | 124 | 2.5% | |
| 99 | 124 | 2.5% | |
| 94 | 124 | 2.5% | |
| 96 | 113 | 2.2% | |
| Other values (181) | 3707 | 73.5% |
| Value | Count | Frequency (%) | |
| 7 | 2 | < 0.1% | |
| 11 | 1 | < 0.1% | |
| 14 | 1 | < 0.1% | |
| 20 | 1 | < 0.1% | |
| 22 | 7 | 0.1% |
| Value | Count | Frequency (%) | |
| 511 | 1 | < 0.1% | |
| 334 | 1 | < 0.1% | |
| 330 | 1 | < 0.1% | |
| 325 | 1 | < 0.1% | |
| 300 | 1 | < 0.1% |
| Distinct count | 20 |
|---|---|
| Unique (%) | 0.4% |
| Missing | 13 |
| Missing (%) | 0.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.371172962 |
|---|---|
| Minimum | 0 |
| Maximum | 43 |
| Zeros | 2152 |
| Zeros (%) | 42.7% |
| Memory size | 39.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 5 |
| Maximum | 43 |
| Range | 43 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 2.01357592 |
|---|---|
| Coefficient of variation (CV) | 1.468506144 |
| Kurtosis | 52.03373533 |
| Mean | 1.371172962 |
| Median Absolute Deviation (MAD) | 1.357893277 |
| Skewness | 4.384765939 |
| Sum | 6897 |
| Variance | 4.054487986 |
| Value | Count | Frequency (%) | |
| 0 | 2152 | 42.7% | |
| 1 | 1251 | 24.8% | |
| 2 | 716 | 14.2% | |
| 3 | 380 | 7.5% | |
| 4 | 207 | 4.1% | |
| 5 | 114 | 2.3% | |
| 6 | 76 | 1.5% | |
| 7 | 48 | 1.0% | |
| 8 | 37 | 0.7% | |
| 9 | 18 | 0.4% | |
| Other values (9) | 31 | 0.6% | |
| (Missing) | 13 | 0.3% |
| Value | Count | Frequency (%) | |
| 0 | 2152 | 42.7% | |
| 1 | 1251 | 24.8% | |
| 2 | 716 | 14.2% | |
| 3 | 380 | 7.5% | |
| 4 | 207 | 4.1% |
| Value | Count | Frequency (%) | |
| 43 | 1 | < 0.1% | |
| 31 | 1 | < 0.1% | |
| 19 | 1 | < 0.1% | |
| 15 | 6 | 0.1% | |
| 14 | 1 | < 0.1% |
| Distinct count | 914 |
|---|---|
| Unique (%) | 18.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 39.5 KiB |
| Drama | 236 |
|---|---|
| Comedy | 209 |
| Comedy|Drama | 191 |
| Comedy|Drama|Romance | 187 |
| Comedy|Romance | 158 |
| Other values (909) |
| Value | Count | Frequency (%) | |
| Drama | 236 | 4.7% | |
| Comedy | 209 | 4.1% | |
| Comedy|Drama | 191 | 3.8% | |
| Comedy|Drama|Romance | 187 | 3.7% | |
| Comedy|Romance | 158 | 3.1% | |
| Drama|Romance | 152 | 3.0% | |
| Crime|Drama|Thriller | 101 | 2.0% | |
| Horror | 71 | 1.4% | |
| Action|Crime|Drama|Thriller | 68 | 1.3% | |
| Action|Crime|Thriller | 65 | 1.3% | |
| Other values (904) | 3605 | 71.5% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 64 |
|---|---|
| Mean length | 20.31310728 |
| Min length | 5 |
| Distinct count | 4433 |
|---|---|
| Unique (%) | 87.9% |
| Missing | 466 |
| Missing (%) | 9.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 45222609.81 |
|---|---|
| Minimum | 113 |
| Maximum | 760505847 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 39.5 KiB |
Quantile statistics
| Minimum | 113 |
|---|---|
| 5-th percentile | 49525.4 |
| Q1 | 3792188 |
| median | 21784432 |
| Q3 | 57491000 |
| 95-th percentile | 176116785 |
| Maximum | 760505847 |
| Range | 760505734 |
| Interquartile range (IQR) | 53698812 |
Descriptive statistics
| Standard deviation | 66528502.32 |
|---|---|
| Coefficient of variation (CV) | 1.471133634 |
| Kurtosis | 15.85410786 |
| Mean | 45222609.81 |
| Median Absolute Deviation (MAD) | 43527387.83 |
| Skewness | 3.22843245 |
| Sum | 2.069838851e+11 |
| Variance | 4.42604162e+15 |
| Value | Count | Frequency (%) | |
| 5000000 | 4 | 0.1% | |
| 3000000 | 3 | 0.1% | |
| 94061311 | 3 | 0.1% | |
| 8000000 | 3 | 0.1% | |
| 7000000 | 3 | 0.1% | |
| 47000000 | 3 | 0.1% | |
| 5773519 | 3 | 0.1% | |
| 144512310 | 3 | 0.1% | |
| 34964818 | 3 | 0.1% | |
| 177343675 | 3 | 0.1% | |
| Other values (4422) | 4546 | 90.1% | |
| (Missing) | 466 | 9.2% |
| Value | Count | Frequency (%) | |
| 113 | 1 | < 0.1% | |
| 162 | 1 | < 0.1% | |
| 423 | 1 | < 0.1% | |
| 576 | 1 | < 0.1% | |
| 703 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 760505847 | 1 | < 0.1% | |
| 658672302 | 1 | < 0.1% | |
| 652177271 | 1 | < 0.1% | |
| 623279547 | 2 | < 0.1% | |
| 533316061 | 1 | < 0.1% |
imdb_score
Real number (ℝ≥0)
| Distinct count | 78 |
|---|---|
| Unique (%) | 1.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.442137616 |
|---|---|
| Minimum | 1.6 |
| Maximum | 9.5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 39.5 KiB |
Quantile statistics
| Minimum | 1.6 |
|---|---|
| 5-th percentile | 4.4 |
| Q1 | 5.8 |
| median | 6.6 |
| Q3 | 7.2 |
| 95-th percentile | 8.09 |
| Maximum | 9.5 |
| Range | 7.9 |
| Interquartile range (IQR) | 1.4 |
Descriptive statistics
| Standard deviation | 1.125115866 |
|---|---|
| Coefficient of variation (CV) | 0.1746494615 |
| Kurtosis | 0.9356915064 |
| Mean | 6.442137616 |
| Median Absolute Deviation (MAD) | 0.8730186468 |
| Skewness | -0.7414713363 |
| Sum | 32487.7 |
| Variance | 1.265885711 |
| Value | Count | Frequency (%) | |
| 6.7 | 223 | 4.4% | |
| 6.6 | 201 | 4.0% | |
| 7.2 | 195 | 3.9% | |
| 6.5 | 186 | 3.7% | |
| 6.4 | 185 | 3.7% | |
| 7.3 | 184 | 3.6% | |
| 7 | 184 | 3.6% | |
| 7.1 | 181 | 3.6% | |
| 6.8 | 181 | 3.6% | |
| 6.1 | 179 | 3.5% | |
| Other values (68) | 3144 | 62.3% |
| Value | Count | Frequency (%) | |
| 1.6 | 1 | < 0.1% | |
| 1.7 | 1 | < 0.1% | |
| 1.9 | 3 | 0.1% | |
| 2 | 2 | < 0.1% | |
| 2.1 | 3 | 0.1% |
| Value | Count | Frequency (%) | |
| 9.5 | 1 | < 0.1% | |
| 9.3 | 1 | < 0.1% | |
| 9.2 | 1 | < 0.1% | |
| 9.1 | 3 | 0.1% | |
| 9 | 3 | 0.1% |
language
Categorical
| Distinct count | 48 |
|---|---|
| Unique (%) | 1.0% |
| Missing | 12 |
| Missing (%) | 0.2% |
| Memory size | 39.5 KiB |
| English | |
|---|---|
| French | 73 |
| Spanish | 40 |
| Hindi | 28 |
| Mandarin | 26 |
| Other values (42) | 160 |
| Value | Count | Frequency (%) | |
| English | 4704 | 93.3% | |
| French | 73 | 1.4% | |
| Spanish | 40 | 0.8% | |
| Hindi | 28 | 0.6% | |
| Mandarin | 26 | 0.5% | |
| German | 19 | 0.4% | |
| Japanese | 18 | 0.4% | |
| Cantonese | 11 | 0.2% | |
| Italian | 11 | 0.2% | |
| Russian | 11 | 0.2% | |
| Other values (37) | 90 | 1.8% | |
| (Missing) | 12 | 0.2% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 10 |
|---|---|
| Mean length | 6.971247273 |
| Min length | 3 |
| Distinct count | 876 |
|---|---|
| Unique (%) | 17.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7525.964505 |
|---|---|
| Minimum | 0 |
| Maximum | 349000 |
| Zeros | 2181 |
| Zeros (%) | 43.2% |
| Memory size | 39.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 166 |
| Q3 | 3000 |
| 95-th percentile | 40000 |
| Maximum | 349000 |
| Range | 349000 |
| Interquartile range (IQR) | 3000 |
Descriptive statistics
| Standard deviation | 19320.44511 |
|---|---|
| Coefficient of variation (CV) | 2.567171968 |
| Kurtosis | 41.33443692 |
| Mean | 7525.964505 |
| Median Absolute Deviation (MAD) | 11022.02801 |
| Skewness | 5.05892689 |
| Sum | 37953439 |
| Variance | 373279599.2 |
| Value | Count | Frequency (%) | |
| 0 | 2181 | 43.2% | |
| 1000 | 109 | 2.2% | |
| 11000 | 83 | 1.6% | |
| 10000 | 81 | 1.6% | |
| 12000 | 62 | 1.2% | |
| 13000 | 58 | 1.2% | |
| 2000 | 56 | 1.1% | |
| 15000 | 53 | 1.1% | |
| 14000 | 50 | 1.0% | |
| 16000 | 47 | 0.9% | |
| Other values (866) | 2263 | 44.9% |
| Value | Count | Frequency (%) | |
| 0 | 2181 | 43.2% | |
| 2 | 2 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 4 | 5 | 0.1% | |
| 5 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 349000 | 1 | < 0.1% | |
| 199000 | 1 | < 0.1% | |
| 197000 | 1 | < 0.1% | |
| 191000 | 1 | < 0.1% | |
| 190000 | 1 | < 0.1% |
| Distinct count | 4919 |
|---|---|
| Unique (%) | 97.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 39.5 KiB |
| http://www.imdb.com/title/tt0077651/?ref_=fn_tt_tt_1 | 3 |
|---|---|
| http://www.imdb.com/title/tt2224026/?ref_=fn_tt_tt_1 | 3 |
| http://www.imdb.com/title/tt0360717/?ref_=fn_tt_tt_1 | 3 |
| http://www.imdb.com/title/tt1976009/?ref_=fn_tt_tt_1 | 3 |
| http://www.imdb.com/title/tt2638144/?ref_=fn_tt_tt_1 | 3 |
| Other values (4914) |
| Value | Count | Frequency (%) | |
| http://www.imdb.com/title/tt0077651/?ref_=fn_tt_tt_1 | 3 | 0.1% | |
| http://www.imdb.com/title/tt2224026/?ref_=fn_tt_tt_1 | 3 | 0.1% | |
| http://www.imdb.com/title/tt0360717/?ref_=fn_tt_tt_1 | 3 | 0.1% | |
| http://www.imdb.com/title/tt1976009/?ref_=fn_tt_tt_1 | 3 | 0.1% | |
| http://www.imdb.com/title/tt2638144/?ref_=fn_tt_tt_1 | 3 | 0.1% | |
| http://www.imdb.com/title/tt0232500/?ref_=fn_tt_tt_1 | 3 | 0.1% | |
| http://www.imdb.com/title/tt3332064/?ref_=fn_tt_tt_1 | 3 | 0.1% | |
| http://www.imdb.com/title/tt1267297/?ref_=fn_tt_tt_1 | 2 | < 0.1% | |
| http://www.imdb.com/title/tt0318974/?ref_=fn_tt_tt_1 | 2 | < 0.1% | |
| http://www.imdb.com/title/tt1502712/?ref_=fn_tt_tt_1 | 2 | < 0.1% | |
| Other values (4909) | 5016 | 99.5% |
| Value | Count | Frequency (%) | |
| http | 5043 | 100.0% |
| Value | Count | Frequency (%) | |
| www.imdb.com | 5043 | 100.0% |
| Value | Count | Frequency (%) | |
| /title/tt3332064/ | 3 | 0.1% | |
| /title/tt0360717/ | 3 | 0.1% | |
| /title/tt0077651/ | 3 | 0.1% | |
| /title/tt2638144/ | 3 | 0.1% | |
| /title/tt0232500/ | 3 | 0.1% | |
| /title/tt1976009/ | 3 | 0.1% | |
| /title/tt2224026/ | 3 | 0.1% | |
| /title/tt1666335/ | 2 | < 0.1% | |
| /title/tt0087800/ | 2 | < 0.1% | |
| /title/tt0299977/ | 2 | < 0.1% | |
| Other values (4909) | 5016 | 99.5% |
| Value | Count | Frequency (%) | |
| ref_=fn_tt_tt_1 | 5043 | 100.0% |
| Value | Count | Frequency (%) | |
| 5043 | 100.0% |
| Distinct count | 4917 |
|---|---|
| Unique (%) | 97.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 39.5 KiB |
| Home | 3 |
|---|---|
| King Kong | 3 |
| The Fast and the Furious | 3 |
| Pan | 3 |
| Halloween | 3 |
| Other values (4912) |
| Value | Count | Frequency (%) | |
| Home | 3 | 0.1% | |
| King Kong | 3 | 0.1% | |
| The Fast and the Furious | 3 | 0.1% | |
| Pan | 3 | 0.1% | |
| Halloween | 3 | 0.1% | |
| Ben-Hur | 3 | 0.1% | |
| Victor Frankenstein | 3 | 0.1% | |
| The Legend of Tarzan | 2 | < 0.1% | |
| Snitch | 2 | < 0.1% | |
| Aloha | 2 | < 0.1% | |
| Other values (4907) | 5016 | 99.5% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | True |
| Contains non-words | True |
Length
| Max length | 87 |
|---|---|
| Mean length | 16.54967281 |
| Min length | 2 |
num_critic_for_reviews
Real number (ℝ≥0)
| Distinct count | 529 |
|---|---|
| Unique (%) | 10.5% |
| Missing | 50 |
| Missing (%) | 1.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 140.194272 |
|---|---|
| Minimum | 1 |
| Maximum | 813 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 39.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 9 |
| Q1 | 50 |
| median | 110 |
| Q3 | 195 |
| 95-th percentile | 387 |
| Maximum | 813 |
| Range | 812 |
| Interquartile range (IQR) | 145 |
Descriptive statistics
| Standard deviation | 121.6016754 |
|---|---|
| Coefficient of variation (CV) | 0.8673797701 |
| Kurtosis | 2.91341641 |
| Mean | 140.194272 |
| Median Absolute Deviation (MAD) | 92.35207408 |
| Skewness | 1.5165327 |
| Sum | 699990 |
| Variance | 14786.96746 |
| Value | Count | Frequency (%) | |
| 1 | 43 | 0.9% | |
| 9 | 37 | 0.7% | |
| 5 | 36 | 0.7% | |
| 10 | 35 | 0.7% | |
| 8 | 35 | 0.7% | |
| 12 | 34 | 0.7% | |
| 81 | 33 | 0.7% | |
| 16 | 33 | 0.7% | |
| 43 | 31 | 0.6% | |
| 29 | 30 | 0.6% | |
| Other values (518) | 4646 | 92.1% | |
| (Missing) | 50 | 1.0% |
| Value | Count | Frequency (%) | |
| 1 | 43 | 0.9% | |
| 2 | 26 | 0.5% | |
| 3 | 24 | 0.5% | |
| 4 | 29 | 0.6% | |
| 5 | 36 | 0.7% |
| Value | Count | Frequency (%) | |
| 813 | 1 | < 0.1% | |
| 775 | 1 | < 0.1% | |
| 765 | 1 | < 0.1% | |
| 750 | 2 | < 0.1% | |
| 739 | 1 | < 0.1% |
num_user_for_reviews
Real number (ℝ≥0)
| Distinct count | 955 |
|---|---|
| Unique (%) | 18.9% |
| Missing | 21 |
| Missing (%) | 0.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 272.7708084 |
|---|---|
| Minimum | 1 |
| Maximum | 5060 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 39.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 10 |
| Q1 | 65 |
| median | 156 |
| Q3 | 326 |
| 95-th percentile | 907.8 |
| Maximum | 5060 |
| Range | 5059 |
| Interquartile range (IQR) | 261 |
Descriptive statistics
| Standard deviation | 377.9828856 |
|---|---|
| Coefficient of variation (CV) | 1.385716044 |
| Kurtosis | 26.43829739 |
| Mean | 272.7708084 |
| Median Absolute Deviation (MAD) | 228.8571855 |
| Skewness | 4.121475159 |
| Sum | 1369855 |
| Variance | 142871.0618 |
| Value | Count | Frequency (%) | |
| 1 | 51 | 1.0% | |
| 3 | 33 | 0.7% | |
| 26 | 32 | 0.6% | |
| 2 | 32 | 0.6% | |
| 10 | 29 | 0.6% | |
| 6 | 28 | 0.6% | |
| 50 | 26 | 0.5% | |
| 32 | 25 | 0.5% | |
| 8 | 25 | 0.5% | |
| 31 | 24 | 0.5% | |
| Other values (944) | 4717 | 93.5% |
| Value | Count | Frequency (%) | |
| 1 | 51 | 1.0% | |
| 2 | 32 | 0.6% | |
| 3 | 33 | 0.7% | |
| 4 | 23 | 0.5% | |
| 5 | 19 | 0.4% |
| Value | Count | Frequency (%) | |
| 5060 | 1 | < 0.1% | |
| 4667 | 1 | < 0.1% | |
| 4144 | 1 | < 0.1% | |
| 3646 | 1 | < 0.1% | |
| 3597 | 1 | < 0.1% |
num_voted_users
Real number (ℝ≥0)
| Distinct count | 4826 |
|---|---|
| Unique (%) | 95.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 83668.16082 |
|---|---|
| Minimum | 5 |
| Maximum | 1689764 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 39.5 KiB |
Quantile statistics
| Minimum | 5 |
|---|---|
| 5-th percentile | 514.6 |
| Q1 | 8593.5 |
| median | 34359 |
| Q3 | 96309 |
| 95-th percentile | 332254.9 |
| Maximum | 1689764 |
| Range | 1689759 |
| Interquartile range (IQR) | 87715.5 |
Descriptive statistics
| Standard deviation | 138485.2568 |
|---|---|
| Coefficient of variation (CV) | 1.655172714 |
| Kurtosis | 24.44552017 |
| Mean | 83668.16082 |
| Median Absolute Deviation (MAD) | 84252.04372 |
| Skewness | 4.029871144 |
| Sum | 421938535 |
| Variance | 1.917816635e+10 |
| Value | Count | Frequency (%) | |
| 57 | 5 | 0.1% | |
| 6 | 4 | 0.1% | |
| 6025 | 3 | 0.1% | |
| 374 | 3 | 0.1% | |
| 53 | 3 | 0.1% | |
| 3119 | 3 | 0.1% | |
| 62 | 3 | 0.1% | |
| 162 | 3 | 0.1% | |
| 2541 | 3 | 0.1% | |
| 8 | 3 | 0.1% | |
| Other values (4816) | 5010 | 99.3% |
| Value | Count | Frequency (%) | |
| 5 | 2 | < 0.1% | |
| 6 | 4 | 0.1% | |
| 7 | 2 | < 0.1% | |
| 8 | 3 | 0.1% | |
| 10 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 1689764 | 1 | < 0.1% | |
| 1676169 | 1 | < 0.1% | |
| 1468200 | 1 | < 0.1% | |
| 1347461 | 1 | < 0.1% | |
| 1324680 | 1 | < 0.1% |
| Distinct count | 4761 |
|---|---|
| Unique (%) | 94.4% |
| Missing | 153 |
| Missing (%) | 3.0% |
| Memory size | 39.5 KiB |
| based on novel | 4 |
|---|---|
| alien friendship|alien invasion|australia|flying car|mother daughter relationship | 3 |
| eighteen wheeler|illegal street racing|truck|trucker|undercover cop | 3 |
| animal name in title|ape abducts a woman|gorilla|island|king kong | 3 |
| one word title | 3 |
| Other values (4755) |
| Value | Count | Frequency (%) | |
| based on novel | 4 | 0.1% | |
| alien friendship|alien invasion|australia|flying car|mother daughter relationship | 3 | 0.1% | |
| eighteen wheeler|illegal street racing|truck|trucker|undercover cop | 3 | 0.1% | |
| animal name in title|ape abducts a woman|gorilla|island|king kong | 3 | 0.1% | |
| one word title | 3 | 0.1% | |
| halloween|masked killer|michael myers|slasher|trick or treat | 3 | 0.1% | |
| 1940s|child hero|fantasy world|orphan|reference to peter pan | 3 | 0.1% | |
| assistant|experiment|frankenstein|medical student|scientist | 3 | 0.1% | |
| sandman|spider man|symbiote|venom|villain | 2 | < 0.1% | |
| audition|friendship|graduation|high school graduation|love | 2 | < 0.1% | |
| Other values (4750) | 4861 | 96.4% | |
| (Missing) | 153 | 3.0% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | True |
| Contains non-words | True |
Length
| Max length | 149 |
|---|---|
| Mean length | 50.92742415 |
| Min length | 2 |
| Distinct count | 92 |
|---|---|
| Unique (%) | 1.8% |
| Missing | 108 |
| Missing (%) | 2.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2002.470517 |
|---|---|
| Minimum | 1916 |
| Maximum | 2016 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 39.5 KiB |
Quantile statistics
| Minimum | 1916 |
|---|---|
| 5-th percentile | 1979 |
| Q1 | 1999 |
| median | 2005 |
| Q3 | 2011 |
| 95-th percentile | 2015 |
| Maximum | 2016 |
| Range | 100 |
| Interquartile range (IQR) | 12 |
Descriptive statistics
| Standard deviation | 12.47459892 |
|---|---|
| Coefficient of variation (CV) | 0.006229604289 |
| Kurtosis | 7.439212616 |
| Mean | 2002.470517 |
| Median Absolute Deviation (MAD) | 8.554733481 |
| Skewness | -2.29227335 |
| Sum | 9882192 |
| Variance | 155.6156182 |
| Value | Count | Frequency (%) | |
| 2009 | 260 | 5.2% | |
| 2014 | 252 | 5.0% | |
| 2006 | 239 | 4.7% | |
| 2013 | 237 | 4.7% | |
| 2010 | 230 | 4.6% | |
| 2015 | 226 | 4.5% | |
| 2008 | 225 | 4.5% | |
| 2011 | 225 | 4.5% | |
| 2005 | 221 | 4.4% | |
| 2012 | 221 | 4.4% | |
| Other values (81) | 2599 | 51.5% |
| Value | Count | Frequency (%) | |
| 1916 | 1 | < 0.1% | |
| 1920 | 1 | < 0.1% | |
| 1925 | 1 | < 0.1% | |
| 1927 | 1 | < 0.1% | |
| 1929 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 2016 | 106 | 2.1% | |
| 2015 | 226 | 4.5% | |
| 2014 | 252 | 5.0% | |
| 2013 | 237 | 4.7% | |
| 2012 | 221 | 4.4% |
First rows
| actor_1_fb_likes | actor_1_name | actor_2_fb_likes | actor_2_name | actor_3_fb_likes | actor_3_name | aspect_ratio | budget | cast_total_fb_likes | color | content_rating | country | director_fb_likes | director_name | duration | facenumber_in_poster | genres | gross | imdb_score | language | movie_fb_likes | movie_imdb_link | movie_title | num_critic_for_reviews | num_user_for_reviews | num_voted_users | plot_keywords | title_year | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1000.0 | CCH Pounder | 936.0 | Joel David Moore | 855.0 | Wes Studi | 1.78 | 237000000.0 | 4834 | Color | PG-13 | USA | 0.0 | James Cameron | 178.0 | 0.0 | Action|Adventure|Fantasy|Sci-Fi | 760505847.0 | 7.9 | English | 33000 | http://www.imdb.com/title/tt0499549/?ref_=fn_tt_tt_1 | Avatar | 723.0 | 3054.0 | 886204 | avatar|future|marine|native|paraplegic | 2009.0 |
| 1 | 40000.0 | Johnny Depp | 5000.0 | Orlando Bloom | 1000.0 | Jack Davenport | 2.35 | 300000000.0 | 48350 | Color | PG-13 | USA | 563.0 | Gore Verbinski | 169.0 | 0.0 | Action|Adventure|Fantasy | 309404152.0 | 7.1 | English | 0 | http://www.imdb.com/title/tt0449088/?ref_=fn_tt_tt_1 | Pirates of the Caribbean: At World's End | 302.0 | 1238.0 | 471220 | goddess|marriage ceremony|marriage proposal|pirate|singapore | 2007.0 |
| 2 | 11000.0 | Christoph Waltz | 393.0 | Rory Kinnear | 161.0 | Stephanie Sigman | 2.35 | 245000000.0 | 11700 | Color | PG-13 | UK | 0.0 | Sam Mendes | 148.0 | 1.0 | Action|Adventure|Thriller | 200074175.0 | 6.8 | English | 85000 | http://www.imdb.com/title/tt2379713/?ref_=fn_tt_tt_1 | Spectre | 602.0 | 994.0 | 275868 | bomb|espionage|sequel|spy|terrorist | 2015.0 |
| 3 | 27000.0 | Tom Hardy | 23000.0 | Christian Bale | 23000.0 | Joseph Gordon-Levitt | 2.35 | 250000000.0 | 106759 | Color | PG-13 | USA | 22000.0 | Christopher Nolan | 164.0 | 0.0 | Action|Thriller | 448130642.0 | 8.5 | English | 164000 | http://www.imdb.com/title/tt1345836/?ref_=fn_tt_tt_1 | The Dark Knight Rises | 813.0 | 2701.0 | 1144337 | deception|imprisonment|lawlessness|police officer|terrorist plot | 2012.0 |
| 4 | 131.0 | Doug Walker | 12.0 | Rob Walker | NaN | NaN | NaN | NaN | 143 | NaN | NaN | NaN | 131.0 | Doug Walker | NaN | 0.0 | Documentary | NaN | 7.1 | NaN | 0 | http://www.imdb.com/title/tt5289954/?ref_=fn_tt_tt_1 | Star Wars: Episode VII - The Force Awakens | NaN | NaN | 8 | NaN | NaN |
| 5 | 640.0 | Daryl Sabara | 632.0 | Samantha Morton | 530.0 | Polly Walker | 2.35 | 263700000.0 | 1873 | Color | PG-13 | USA | 475.0 | Andrew Stanton | 132.0 | 1.0 | Action|Adventure|Sci-Fi | 73058679.0 | 6.6 | English | 24000 | http://www.imdb.com/title/tt0401729/?ref_=fn_tt_tt_1 | John Carter | 462.0 | 738.0 | 212204 | alien|american civil war|male nipple|mars|princess | 2012.0 |
| 6 | 24000.0 | J.K. Simmons | 11000.0 | James Franco | 4000.0 | Kirsten Dunst | 2.35 | 258000000.0 | 46055 | Color | PG-13 | USA | 0.0 | Sam Raimi | 156.0 | 0.0 | Action|Adventure|Romance | 336530303.0 | 6.2 | English | 0 | http://www.imdb.com/title/tt0413300/?ref_=fn_tt_tt_1 | Spider-Man 3 | 392.0 | 1902.0 | 383056 | sandman|spider man|symbiote|venom|villain | 2007.0 |
| 7 | 799.0 | Brad Garrett | 553.0 | Donna Murphy | 284.0 | M.C. Gainey | 1.85 | 260000000.0 | 2036 | Color | PG | USA | 15.0 | Nathan Greno | 100.0 | 1.0 | Adventure|Animation|Comedy|Family|Fantasy|Musical|Romance | 200807262.0 | 7.8 | English | 29000 | http://www.imdb.com/title/tt0398286/?ref_=fn_tt_tt_1 | Tangled | 324.0 | 387.0 | 294810 | 17th century|based on fairy tale|disney|flower|tower | 2010.0 |
| 8 | 26000.0 | Chris Hemsworth | 21000.0 | Robert Downey Jr. | 19000.0 | Scarlett Johansson | 2.35 | 250000000.0 | 92000 | Color | PG-13 | USA | 0.0 | Joss Whedon | 141.0 | 4.0 | Action|Adventure|Sci-Fi | 458991599.0 | 7.5 | English | 118000 | http://www.imdb.com/title/tt2395427/?ref_=fn_tt_tt_1 | Avengers: Age of Ultron | 635.0 | 1117.0 | 462669 | artificial intelligence|based on comic book|captain america|marvel cinematic universe|superhero | 2015.0 |
| 9 | 25000.0 | Alan Rickman | 11000.0 | Daniel Radcliffe | 10000.0 | Rupert Grint | 2.35 | 250000000.0 | 58753 | Color | PG | UK | 282.0 | David Yates | 153.0 | 3.0 | Adventure|Family|Fantasy|Mystery | 301956980.0 | 7.5 | English | 10000 | http://www.imdb.com/title/tt0417741/?ref_=fn_tt_tt_1 | Harry Potter and the Half-Blood Prince | 375.0 | 973.0 | 321795 | blood|book|love|potion|professor | 2009.0 |
Last rows
| actor_1_fb_likes | actor_1_name | actor_2_fb_likes | actor_2_name | actor_3_fb_likes | actor_3_name | aspect_ratio | budget | cast_total_fb_likes | color | content_rating | country | director_fb_likes | director_name | duration | facenumber_in_poster | genres | gross | imdb_score | language | movie_fb_likes | movie_imdb_link | movie_title | num_critic_for_reviews | num_user_for_reviews | num_voted_users | plot_keywords | title_year | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5033 | 291.0 | Shane Carruth | 45.0 | David Sullivan | 8.0 | Casey Gooden | 1.85 | 7000.0 | 368 | Color | PG-13 | USA | 291.0 | Shane Carruth | 77.0 | 0.0 | Drama|Sci-Fi|Thriller | 424760.0 | 7.0 | English | 19000 | http://www.imdb.com/title/tt0390384/?ref_=fn_tt_tt_1 | Primer | 143.0 | 371.0 | 72639 | changing the future|independent film|invention|nonlinear timeline|time travel | 2004.0 |
| 5034 | 0.0 | Ian Gamazon | 0.0 | Edgar Tancangco | 0.0 | Quynn Ton | NaN | 7000.0 | 0 | Color | Not Rated | Philippines | 0.0 | Neill Dela Llana | 80.0 | 0.0 | Thriller | 70071.0 | 6.3 | English | 74 | http://www.imdb.com/title/tt0428303/?ref_=fn_tt_tt_1 | Cavite | 35.0 | 35.0 | 589 | jihad|mindanao|philippines|security guard|squatter | 2005.0 |
| 5035 | 121.0 | Carlos Gallardo | 20.0 | Peter Marquardt | 6.0 | Consuelo Gómez | 1.37 | 7000.0 | 147 | Color | R | USA | 0.0 | Robert Rodriguez | 81.0 | 0.0 | Action|Crime|Drama|Romance|Thriller | 2040920.0 | 6.9 | Spanish | 0 | http://www.imdb.com/title/tt0104815/?ref_=fn_tt_tt_1 | El Mariachi | 56.0 | 130.0 | 52055 | assassin|death|guitar|gun|mariachi | 1992.0 |
| 5036 | 45.0 | Richard Jewell | 44.0 | John Considine | 2.0 | Sara Stepnicka | NaN | 3250.0 | 93 | Color | PG-13 | USA | 2.0 | Anthony Vallone | 84.0 | 0.0 | Crime|Drama | NaN | 7.8 | English | 4 | http://www.imdb.com/title/tt0430371/?ref_=fn_tt_tt_1 | The Mongol King | NaN | 1.0 | 36 | jewell|mongol|nostradamus|stepnicka|vallone | 2005.0 |
| 5037 | 296.0 | Kerry Bishé | 205.0 | Caitlin FitzGerald | 133.0 | Daniella Pineda | NaN | 9000.0 | 690 | Color | Not Rated | USA | 0.0 | Edward Burns | 95.0 | 1.0 | Comedy|Drama | 4584.0 | 6.4 | English | 413 | http://www.imdb.com/title/tt1880418/?ref_=fn_tt_tt_1 | Newlyweds | 14.0 | 14.0 | 1338 | written and directed by cast member | 2011.0 |
| 5038 | 637.0 | Eric Mabius | 470.0 | Daphne Zuniga | 318.0 | Crystal Lowe | NaN | NaN | 2283 | Color | NaN | Canada | 2.0 | Scott Smith | 87.0 | 2.0 | Comedy|Drama | NaN | 7.7 | English | 84 | http://www.imdb.com/title/tt3000844/?ref_=fn_tt_tt_1 | Signed Sealed Delivered | 1.0 | 6.0 | 629 | fraud|postal worker|prison|theft|trial | 2013.0 |
| 5039 | 841.0 | Natalie Zea | 593.0 | Valorie Curry | 319.0 | Sam Underwood | 16.00 | NaN | 1753 | Color | TV-14 | USA | NaN | NaN | 43.0 | 1.0 | Crime|Drama|Mystery|Thriller | NaN | 7.5 | English | 32000 | http://www.imdb.com/title/tt2071645/?ref_=fn_tt_tt_1 | The Following | 43.0 | 359.0 | 73839 | cult|fbi|hideout|prison escape|serial killer | NaN |
| 5040 | 0.0 | Eva Boehnke | 0.0 | Maxwell Moody | 0.0 | David Chandler | NaN | 1400.0 | 0 | Color | NaN | USA | 0.0 | Benjamin Roberds | 76.0 | 0.0 | Drama|Horror|Thriller | NaN | 6.3 | English | 16 | http://www.imdb.com/title/tt2107644/?ref_=fn_tt_tt_1 | A Plague So Pleasant | 13.0 | 3.0 | 38 | NaN | 2013.0 |
| 5041 | 946.0 | Alan Ruck | 719.0 | Daniel Henney | 489.0 | Eliza Coupe | 2.35 | NaN | 2386 | Color | PG-13 | USA | 0.0 | Daniel Hsia | 100.0 | 5.0 | Comedy|Drama|Romance | 10443.0 | 6.3 | English | 660 | http://www.imdb.com/title/tt2070597/?ref_=fn_tt_tt_1 | Shanghai Calling | 14.0 | 9.0 | 1255 | NaN | 2012.0 |
| 5042 | 86.0 | John August | 23.0 | Brian Herzlinger | 16.0 | Jon Gunn | 1.85 | 1100.0 | 163 | Color | PG | USA | 16.0 | Jon Gunn | 90.0 | 0.0 | Documentary | 85222.0 | 6.6 | English | 456 | http://www.imdb.com/title/tt0378407/?ref_=fn_tt_tt_1 | My Date with Drew | 43.0 | 84.0 | 4285 | actress name in title|crush|date|four word title|video camera | 2004.0 |